CODEWITHSUNDEEP
azureazure-data-factoryazure-synapse
Gabriel Padilha
Gabriel Padilha

Reputation: 159

Synapse Analytics save a query result in a blob storage

So, I have some parquet files stored in azure devops containers inside a blob storaged. I used data factory pipeline with the "copy data" connector to extract the data from a on premise Oracle database.

I'm using Synapse Analytics to do a sql query that uses some of the parquet files store in the blob container and I want to save the results of the query in another blob. Which Synapse connector can I use the make this happen? To do the query I'm using the "develop" menu inside Synapse Analytics.

Upvotes: 0

Views: 1037

Answers (1)

Joel Cochran
Joel Cochran

Reputation: 7768

To persist the results of a serverless SQL query, use CREATE EXTERNAL TABLE AS SELECT (CETAS). This will create a physical copy of the result data in your storage account as a collection of files in a folder, so you cannot specify how many files nor the naming scheme of the files.

Upvotes: 1

Related Questions