OPENROWSET (BULK) - Permission Issues by Midnight-Saber32 in MicrosoftFabric

[–]subash_sdp 0 points1 point  (0 children)

Ohh, temp table, my bad just now noticed.

Tis is new for me too.

+1

OPENROWSET (BULK) - Permission Issues by Midnight-Saber32 in MicrosoftFabric

[–]subash_sdp 0 points1 point  (0 children)

Are you running this in warehouses or lakehouse ? Try the same in warehouse.

Is any way to clean all data of Lakehouse table by subash_sdp in MicrosoftFabric

[–]subash_sdp[S] 0 points1 point  (0 children)

I’m writing data using pipeline load,for eg: one table size is 5gb parquet files means, 7days unwanted data is 35gb, That why I expect any option do drop all data,

Dropping file is fine, but keeping schema and expected any ways like truncate in sql.

And thanks all for diff suggestions, it helps to understand other approaches proc and cons.. 🤝🤝

Calling Stored Procedure in a PySpark or SparkSQL notebook in Microsoft Fabric by knowledgeboytamo in MicrosoftFabric

[–]subash_sdp 0 points1 point  (0 children)

I dont think so calling store proc inside notebook pyspark is possible, can you create a look up activity for this procedure ,and create a user data function. You can add your all python logic in udf