locked
Synapse - External Table RRS feed

  • Question

  • I have loosely followed the instructions in the link below to create a connection from Synapse (Azure Data Warehouse) to a blob storage set up as an ADL.

    All commands execute, the connection, the format, and the table.  However, when I try to query the external table, no data.

    https://docs.microsoft.com/en-us/azure/sql-data-warehouse/load-data-from-azure-blob-storage-using-polybase

    Blob Container:

    containerA-->Folder1-->3 .csv files

    DataSource = abfss://containerA@azurestorageadl.blob.core.windows.net

    Created the external table where the location = '/Folder1'

    I'm stuck in where to look as to why there is no data when I query for it.  No errors, just no data.

    Saturday, February 15, 2020 3:47 PM

Answers

All replies