We have used ODBC to connect Palantir Foundry as a source successfully but we are unable to import tables because the table name is something like this.
“/ls/ls-use-case-erp-material-master-data-for-ecommerce/ERP Master Data/Emerald_MARA_MVKE_CN”
So, we have used SQL Transform and placed the below query but when we click on Update schema, it is throwing an error as below. Though it errored out, we manually added all column names in the SQL Transform structure and then run the job
Foundry Query :
SELECT * FROM “/Life Science/ls-use-case-erp-material-master-data-for-ecommerce/ERP Master Data/Emerald_MARA_MVKE_CN”
Please assist in how to resolve this ODBC issue.