Defining Key in Redis destination and writing to CockroachDB

Summary

The user is asking how to define the Key in a Redis destination when syncing from Snowflake and how to write to CockroachDB.


Question

:wave: Hi, I wonder if you can help me with two questions:

  1. How can I define the Key in a Redis destination? Iā€™m syncing from snowflake and want to set the key to a table column
  2. How can I write to cockroachDB?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["define-key", "redis-destination", "snowflake", "cockroachdb", "write"]

Ad. 1. Key has format: namespace:stream:id , where id is generated by using the INCR Redis command
https://docs.airbyte.com/integrations/destinations/redis
You would have to change the code of https://github.com/airbytehq/airbyte/tree/5e17bbc604fc20b3d18e7205d437a85d8c419755/airbyte-integrations/connectors/destination-redis|destination-redis and build your own custom connector to have something different.

Ad. 2. There is no destination connector for CockroachDB. You can contribute to Airbyte by implementing missing connector.