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: