ODBC SQl Query Connection but No Data

[Anonymous]

Hello,

Due to the system limitations, I am only able to use a SQL query with ODBC to connect to the data table. However, only the columns pull and no data generates. Freshing the data doesn't work, reestablishing the connection doesn't work, changing the ODBC bit connection doesn't work, and if I try without the SQL query nothing works. Am I missing something in the query to get the data to populate?

= Odbc.Query("dsn=PostgreSQL35W", "SELECT * FROM schema.table WHERE 'reporting_quarter_445' IN ('2018-Q1','2018-Q2','2018-Q3','2018-Q4','2019-Q1','2019-Q2','2019-Q3','2019-Q4','2020-Q1','2020-Q2','2020-Q3','2020-Q4','2021-Q1','2021-Q2','2021-Q3','2021-Q4')")

Thanks!

-Christopher

[ThomasMob]

Was the solution found?

I have the kind of the same problem:

ODBC connection does work, only the tables/data is not loading.

(to make it even more strange: if I put the datagateway on my personal computer (same netwerk, same settup) everything works well).

[v-jayw-msft]

Hi @Anonymous ,

Have you tried excute the same SQL in database? Is there any data?

Best Regards,

Jay

[Anonymous]

Hello @v-jayw-msft 

Thank you for reaching out! Unfortunately, the IT team whom I work with has stated to access the data it is supposed to be the ODBC. 

Edit: The reason for ODBC is because the database is Greenplum based.

Thanks!

-Chris

[amitchandak]

@Anonymous , I think you have mention Query in advance Property.

[Anonymous]

Good Day @amitchandak ,

You are correct. The Query is in the advance property, but there is no data in the results. I can get a connection and the columns to populate, but none of the information.

Below is a screenshot of the advanced options filled out, as you have shown:

Below is the query showing the columns, but no information in the table (even though there is in the system):

Thanks!

-Chris