Snowflake Native Query not supported

[rem-bou]

Describe the issue
Creating a table using native query with snowflake as datasource returns a table with no partition and no column. It is basically an empty shell. Update schema is not available either.
I am using SSO and I am able to import tables/views from snowflake with no issues.

** Which version are you currently using? **
Using TE3.8.0

To Reproduce
I have tried while working offline but also using PowerBI to host model.

Steps to reproduce the behavior:

1. Right Click on 'Tables'
2. Click on 'Import tables'
3. Click on 'Use implicit data source...'
4. Select data source 'Snowflake'
5. Enter Server, Warehouse, Database ans select OAuth for Browser
6. Click on 'Ok'
7. Click on 'Provide a SQL statement to execute natively against the data source'
8. Wrtie the SQL statement: Example SELECT * FROM Database.Schema.TableName

Expected behavior
TE3 would create partition with M code as well as detecting columns from query and importing them.

Screenshots

Desktop (please complete the following information):

• Windows version 10

[mlonsk]

Hi @rem-bou

Thank you for reporting, we will look into getting this fixed.

[otykier]

This is now fixed in 3.12.0. Note, that you need to specify the database/catalog name when initially creating the connection to Snowflake, for the native SQL option to be available on the next page in the Import Table Wizard.