Before you begin
You have an ADLS Databricks file in your cluster. For
example:
abfss://filelocationpath.dfs.core.windows.net/ems/
Procedure
-
Double-click the component to open its settings.
-
Enter the code in the Code field. For example:
ss.sql("CREATE EXTERNAL TABLE if not exists talend.test (id int, email
string)ROW FORMAT DELIMITED FIELDS TERMINATED BY ';'lines terminated by '\n'
STORED AS TEXTFILE LOCATION
\'abfss://filelocationpath.dfs.core.windows.net/ems/\'");