forcedotcom / Salesforce-CDP-jdbc

JDBC driver to connect to Salesforce CDP.
Apache License 2.0
32 stars 28 forks source link

Connector fails when fetching Salesforce CDP date/time fields #82

Open pnewall opened 2 years ago

pnewall commented 2 years ago
  1. From Tableau Desktop, select as a data source any data lake object or data model object which contains a date/time field
  2. Update the data source to try & view the new set of fields
  3. Attached error is returned cdp_date_error

    OR

  4. From DBeaver, do a SQL select on any data lake object or data model object
  5. Select should contain just a few fields e.g id, name AND a date/time field
  6. Query fails & returns no rows
  7. Remove date/time field from the select
  8. Re-run the select & it completes