hasura / hasura/graphql-engine

Support migrations on source cockroachcloud of kind cockroach

Open
#9,217 1 comment 0 reactions 0 assignees View on GitHub
k/enhancement t/product-platform
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information

Server Version:
CLI Version (for CLI related issue): v2.15.1

### Environment

Cloud (with CockroachDB Cloud)

### What is the current behaviour?

I am trying to follow the steps here ("[Hasura Cloud to Local Dev](https://github.com/hasura/github-integration-starter#moving-from-hasura-cloud-to-local-dev)") to manage my remote CockroachDB Cloud schema via the Hasura Github integration.

Unfortunately when I try to run `hasura migrate create init --from-server --endpoint https://myproject.hasura.app --admin-secret *mysecret*`, I get the error message: `time="2022-11-17T13:56:22+10:00" level=fatal msg="migrations on source cockroachcloud of kind cockroach is not supported"`

### What is the expected behaviour?

Cockroach-cli produces migrations files, allowing me to manage my CockroachDB schema from Hasura cloud (via Github integration).

### How to reproduce the issue?

1. Create a CockroachDB cloud account
2. Connect Hasura Cloud to CockroachDB Cloud
3. Run `hasura init myproject` then hasura migrate create init --from-server --endpoint https://myproject.hasura.app --admin-secret *mysecret*`

### Screenshots or Screencast

```
PS C:\proj\dvasdekis_try_hasura_cockroach\services\hasura> hasura migrate create init --from-server --endpoint https://myproject.hasura.app --admin-secret mysecret

? Select a database to use
> cockroachcloud

time="2022-11-17T13:56:22+10:00" level=fatal msg="migrations on source cockroachcloud of kind cockroach is not supported"
```

Contributor guide

Open the contributing guide

Research direction

Start with the `hasura migrate create ... --from-server` command and trace where the `cockroachcloud` source of kind `cockroach` is rejected. Confirm the migration-generation path for this source and validate the expected result by reproducing the documented CockroachDB Cloud workflow; done means migration files are produced instead of the unsupported-source error.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
cli, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.