string_is_quoted
def string_is_quoted(string: str) -> boolArguments:
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):
defaultOptional[Any], optional - (Default value = None)requiredbool, optional - (Default value = True)validatorOptional[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.SnowflakeConnectionArguments:
Returns:
close
def close() -> NoneArguments:
Returns:
query_runner
def query_runner(query: str, param_dict: Dict = {}) -> List[Dict]Arguments:
query (str):
param_dictDict, 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: