Forum Discussion
Copy INTO from authenticated source
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
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
3 Replies
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
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,
DennesDennesTorres 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
