How to Load Data from Microsoft Azure Blob Storage to Teradata Vantage - Foreign Table
Load Data from Microsoft Azure Blob Storage to Teradata Vantage
CREATE DATABASE Project FROM DBC AS PERM = 1000000000;
drop AUTHORIZATION Project.DefAuth_AZ
CREATE AUTHORIZATION Project.DefAuth_AZ
AS DEFINER TRUSTED
USER '' /* Storage Account Name */
PASSWORD ''; /* Storage Account Access Key or SAS Token */
CREATE MULTISET FOREIGN TABLE employee
,EXTERNAL SECURITY DEFINER TRUSTED DefAuth_AZ (
Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
Payload DATASET INLINE LENGTH 64000 STORAGE FORMAT CSV
)
USING (
LOCATION ('/AZ/vantageloadingaccount.blob.core.windows.net/employee/employee.csv')
)
NO PRIMARY INDEX;
show table employee
SELECT location, payload.*
FROM employee Sample 10;
create view employee_View_ as
(
select payload..EMPLOYEE_ID as EMPLOYEE_ID ,
payload..FIRST_NAME as FIRST_NAME,
payload..LAST_NAME as LAST_NAME,
payload..SALARY as SALARY,
payload..DEPARTMENT_ID as DEPARTMENT_ID
from employee
)