Questions tagged [cloudant-sdp]

Cloudant schema discovery process (SDP) scans a Cloudant database and intuits the implicit structures in your data. It then creates that proper schema in dashDB and copies the data over.

DashDB is built on a relational database, where the data is stored in structured relational tables. Cloudant stores JSON documents, where all the data is encapsulated in a single record. To move data between these two systems we need to be able to translate our JSON docs into a schema (or set of tables) that dashDB understands. This is exactly what the SDP does. It scans your Cloudant database and intuits the implicit structures in your data. It then creates that proper schema in dashDB and copies the data over.

Source: https://cloudant.com/blog/introducing-data-warehousing-and-analytics-with-cloudant-and-dashdb/#.VXrvwudnlK4

18 questions
0
votes
1 answer

How can I debug problems with warehouse creation?

When trying to create a warehouse from the Cloudant dashboard, sometimes the process fails with an error dialog. Other times, the warehouse extraction stays in a state of triggered even after hours. How can I debug this? For example is there an…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

How can I tell if my SDP process is still running the 'initial' load?

You cannot run any sql statements on a DashDB that result in locks that will conflict with the schema discovery process (SDP) during the initial load. See here for more information: SQLCODE=-911 : "warehouser_error_message": "File…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

SQLCODE=-911 : "warehouser_error_message": "File <>.csv.zip could not be loaded due to an exception in dashDB

The Cloudant Schema Discovery Process (SDP) is reporting the following error message while loading my dashDB database: "warehouser_error_message": "File xxxxxx/xxxxxx_nnnn_nnn_n_n.csv.zip could not be loaded due to an exception in dashDB. Reason:…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
1
2