Starlake

starcode README

Features

This extension adds the following features:

Preview et edit tables and tasks in tabular mode
Preview data lineage
Preview table access control rules
Preview table relationships
Run and Dry-run SQL queries (BigQuery only)
SQL auto-complete based on table schemas
Run starlake tasks
Validate configuration

Installation

Download https://github.com/starlake-ai/starlake/blob/master/distrib/starlake.sh
Start starlake in server mode starlake.sh serve to listen to this extension requests.

If you start Starlake on another host or port, you need to set the starlake.host and starlake.port settings in the extension settings. To start in server mode on another port you can use the command line option --port PORT

Useful extensions to install

Log Output Colorizer: https://marketplace.visualstudio.com/items?itemName=IBM.output-colorizer
Syntax highlighting for jinja(2) / SQL: https://marketplace.visualstudio.com/items?itemName=samuelcolvin.jinjahtml

About Google Cloud Setup

Make sure that the gcloud command is present in your PATH: This is a requirement for the GCloud API to work.

To list your Google Cloud projects, you first need to set your default application credentials

$ gcloud auth application-default login

Then set a default project

$ gcloud config set core/project MY_PROJECT_ID

Extension Settings

starlake.cliKey: APi Key to your Starlake instance
starlake.host: The server hosting your starlake binary. Defaults to http://127.0.0.1
starlake.port: Port the starlake server is listening on. Defaults to 9900
starlake.metadataDir: Metadata folder name. "metadata" by default