Cockroach is an object-relational database management system.
Cockroach uses and extends the SQL language combined with many other features that safely store and scales the most complicated data workloads.
The native data types that are supported include:
- Primitives: Integer, Numeric, String, Boolean
- Structured: Date/Time, Array, Range, UUID
- Document: JSON/JSONB, XML, Key-value (Hstore)
- Geometry: Point, Line, Circle, Polygon
- Customizations: Composite, Custom Types
Learn more: about Cockroach from Cockroach documentation.
The Cockroach loader is used to load data into a table in the Cockroach database.
Credentials of the database you would like to connect to:
- Name of the database, schema
However, the exact credentials required may depend on your specific setup, as CockroachDB supports a variety of authentication methods.
If you wish to connect to a database outside of the Meiro Integrations environment, you may need a front-end tool like DBeaver, IntelliJ IDEA, or any other front-end (GUI) tool available online. To learn more about these tools, please refer to their respective documentation online. Connecting via a GUI tool is not mandatory, but it may be useful to access the database outside the Meiro Integrations environment.
Cockroach components work only with CSV tables. Other data formats need to be converted to CSV format by processors.
- One file and multi-file tables,
- Header and no header,
- Custom delimiter,
- Automatic creation of the destination table (all data types as a text for columns) and manual override if the user wants to specify the data type for a column.
Data In/Data Out
Learn more: about the folder structure here.
Remember: You should be able to get all the credentials from the database administrator.