Regarding the IMPORT command

Hi Team,

I have a dev cluster for cockroachDB. I am able to connect to cockroachDB using SQL Developer. Is it possible to perform the IMPORT command using SQL Developer or Is it only can be done through CockroachDB Command Shell?

IMPORT TABLE employees (
emp_no INT PRIMARY KEY,
birth_date DATE NOT NULL,
first_name STRING NOT NULL,
last_name STRING NOT NULL,
gender STRING NOT NULL,
hire_date DATE NOT NULL
) CSV DATA (‘https://s3-us-west-1.amazonaws.com/cockroachdb-movr/datasets/employees-db/csv/employees.csv.gz’);

Hello Abdul,

I don’t have much experience with Oracle’s SQL Developer, but the CockroachDB commands in the documentation are intended to be run from the Cockroach CLI. The IMPORT command can be run from the built-in SQL client (cockroach sql).