grai_source_snowflake
loader

string_is_quoted

def string_is_quoted(string: str) -> bool

Arguments:

string (str):

Returns:

get_from_env

def get_from_env(label: str,
                 default: Optional[Any] = None,
                 required: bool = True,
                 validator: Optional[Callable] = None)

Arguments:

label (str):

  • default Optional[Any], optional - (Default value = None)
  • required bool, optional - (Default value = True)
  • validator Optional[Callable], optional - (Default value = None)

Returns:

SnowflakeConnector Objects

class SnowflakeConnector()

connection_dict

@property
def connection_dict() -> Dict[str, str]

Builds connection parameters for Snowflake

Full documentation of the API available here https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-api#label-snowflake-connector-methods (opens in a new tab)

Arguments:

Returns:

connect

def connect() -> "SnowflakeConnector"

Arguments:

Returns:

connection

@property
def connection() -> snowflake.connector.SnowflakeConnection

Arguments:

Returns:

close

def close() -> None

Arguments:

Returns:

query_runner

def query_runner(query: str, param_dict: Dict = {}) -> List[Dict]

Arguments:

query (str):

  • param_dict Dict, optional - (Default value = {})

Returns:

tables

@cached_property
def tables() -> List[Table]

Create and return a list of dictionaries with the schemas and names of tables in the database connected to by the connection argument.

Arguments:

Returns:

columns

@cached_property
def columns() -> List[Column]

Creates and returns a list of dictionaries for the specified schema.table in the database connected to.

Arguments:

Returns:

column_map

@cached_property
def column_map() -> Dict[Tuple[str, str], List[Column]]

Arguments:

Returns:

get_table_columns

def get_table_columns(table: Table)

Arguments:

table (Table):

Returns:

foreign_keys

@cached_property
def foreign_keys() -> List[Edge]

This needs to be tested / evaluated

Arguments:

Returns:

get_nodes

def get_nodes() -> List[SnowflakeNode]

Arguments:

Returns:

get_edges

def get_edges() -> List[Edge]

Arguments:

Returns:

get_nodes_and_edges

def get_nodes_and_edges() -> Tuple[List[SnowflakeNode], List[Edge]]

Arguments:

Returns: