CD2 User Defined data types
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm working with CD2 in PostgreSQL and I'm noticing that CD2 seems to take an opinionated stance on data types with many columns being user defined (typically enums). For example, `context_type` in `lti_resource_links` is of type `lti_resource_links__context_type`
I'm just curious about the rationale? Mostly because I'm having challenges configuring an AWS Athena PostgreSQL connector and there are data type limitations. Has anyone else run into data type challenges with the CD2 schema?
Thanks,
Jeff
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For anyone who finds themselves in this situation, hat tip to my colleague @alison_myers who found that the solution is to use the JDBC connection parameter:
stringtype=unspecified
If you're using Athena Federated Queries with a PostgreSQL database (or JDBC to PostgreSQL generally), this works broadly for user-defined types.