Copy INTO from authenticated source

[DennesTorres]

Hi,

Is there a way to use the COPY INTO SQL statement on a Data Warehouse when the storage source requires authentication?

I imagine an SAS key on the query string would work, but is this the only way? 

Kind Regards,

Dennes

[GeethaT-MSFT]

Hi @DennesTorres Thanks for posting your question in Microsoft Fabric Community

you can use a SAS token or a storage account key with Fabric. If you need an example, you can find it here:COPY INTO (Transact-SQL) - Azure Synapse Analytics and Microsoft Fabric | Microsoft Learn

Regards

Geetha

[DennesTorres]

Thank you, Geetha, this helps if the source is an external storage, such as an azure data lake storage.

If the source is the "Files" area from a lakehouse, is it possible to retrieve an SAS key for the Files area, or is it not available yet ?


Kind Regards,

Dennes

[GeethaT-MSFT · Accepted solution]

@DennesTorres We don't support COPY from OneLake quite yet. If your files are in the Lakehouse, are they delta tables? You can use CTAS from the Lakehouse, or even INSERT INTO ... SELECT. There are some examples in the "Ingesting data from tables on different warehouses and lakehouses" section of this article: Ingest data into your Warehouse using Transact-SQL - Microsoft Fabric | Microsoft Learn

Regards

Geetha