'InfoSphere Data Architect - Snowflake Connector / Generating DDL
I am trying to connect to a Snowflake database via IBM InfoSphere Data Architect (version 9.1.4.1) using JDBC. A couple of questions:
- Is it possible to setup InfoSphere Data Architect to use the actual Snowflake connection and have it listed in my screenshot below? Right now my only option is to use the generic JDBC driver:
IBM IDA - New Database Connection - Picture
- I've been able to connect using the generic JDBC driver, but I am unable to view the data types on the tables correctly:
IBM IDA - Snowflake table showing incorrect data type, DDL Generation missing CLUSTER BY
BANKID shouldn't be shown as BIGINT, instead it should display as NUMBER(38, 0). Also, when I generate the DDL statements, it's missing the 'CLUSTER BY' clause.
Has anyone been able to successfully configure IBM IDA to connect to snowflake and accurately generate DDL scripts? Any help would be much appreciative.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|