CREATE FOREIGN TABLE Statement
CREATE MULTISET FOREIGN TABLE AZURE_TB
, external security invoker trusted InvAuth1_azure
(Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
Payload JSON(8388096) INLINE LENGTH 32000 CHARACTER SET UNICODE)
USING (
LOCATION ('az://extfsazblob.blob.core.windows.net/ddlft/json/')
),
NO PRIMARY INDEX;
SELECT Statement
SELECT * FROM AZURE_TB;
Result:
Location --------------------------------------------------------------------------- AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/emp.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ex_valid.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/example.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ft/ft.json AZ://extfsazblob.blob.core.windows.net/ddlft/json/ut/ut.json