Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Big Query ODBC Connection

hprice
6 - Meteoroid

We are in the process of moving from an Oracle Data Warehouse to Google Big Query. We have the BQ Simba ODBC driver installed and connections are working. However, when we pull numeric values into Alteryx it's adding additional decimals places beyond what we see in Big Query raw data. Example unit cost in BQ is 4.75 Alteryx I believe is adding 38 decimals and displaying 4.75000000000000000000000000000000000000. Data types in BQ are set to Big Numeric or numeric. Is there a different recommended connection other than ODBC? Or a setting we should be changing within Alteryx?

 

 

0 REPLIES 0
Labels