prism connect is used to connect your Prism project to third-party adapters (e.g., Snowflake, Redshift, dbt, etc.)
Usage: prism connect [OPTIONS]
Connect your Prism project to third-party adapters (e.g., Snowflake, BigQuery, PySpark, etc.).
Examples:
• prism connect --type snowflake
• prism connect --type snowflake -v PROFILE_YML_PATH=/Users/.prism/profile.yml
• prism connect --type snowflake --context '{"PROFILE_YML_PATH", "/Users/.prism/profile.yml"}'
─ Options ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╮
│ * --type -t [bigquery|dbt|postgres|pyspark|redshift|snowflake|trino|presto] Connection type │
│ [required] │
│ --log-level -l [info|warn|error|debug] Set the log level │
│ --full-tb Show the full traceback when an error occurs │
│ --vars -v TEXT Variables as key value pairs. These overwrite variables in │
│ prism_project.py. All values are intepreted as strings. │
│ --context TEXT Context as a dictionary. Must be a valid JSON. These overwrite variables │
│ in prism_project.py │
│ --help Show this message and exit. │
╰───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╯
Here's what prism connect does under the hood:
Parses the prism_project.py file and gets the PROFILE_YML_PATH value. If this value isn't specified, then it defaults to the project directory.
It checks to see if PROFILE_YML_PATH exists
If it doesn't, it creates a new YML file at PROFILE_YML_PATH and populates it with a profile of type --type
If it does, it then adds a profile of type --type to the existing file.
Example
Here's what the output will look like in Terminal (if there are no errors in the project):
$ prism connect --type snowflake
--------------------------------------------------------------------------------
<HH:MM:SS> | INFO | Running with prism v0.2.3...
<HH:MM:SS> | INFO | Found project directory at /Users/my_first_project
<HH:MM:SS> | INFO | RUNNING EVENT 'parsing prism_project.py'................................................ [RUN]
<HH:MM:SS> | INFO | FINISHED EVENT 'parsing prism_project.py'............................................... [DONE in 0.03s]
<HH:MM:SS> | INFO | Setting up profile...
<HH:MM:SS> | INFO | Done!
--------------------------------------------------------------------------------
Here's what the profile.yml file looks like after running the above command: