src/astro/sql/operators/sql_decorator.py
def handle_output_table_schema(self, output_table_name, schema=None):
        """
        In postgres, we set the schema in the query itself instead of as a query parameter.
        This function adds the necessary {schema}.{table} notation.
        :param output_table_name:
        :param schema: an optional schema if the output_table has a schema set. Defaults to the temp schema
        :return:
        """
        schema = schema or SCHEMA
        if self.conn_type == "postgres" and self.schema:
            output_table_name = schema + "." + output_table_name
        elif self.conn_type == "snowflake" and self.schema and "." not in self.sql:
            output_table_name = self.database + "." + schema + "." + output_table_name
        return output_table_name

        In postgres, we set the schema in the query itself instead of as a query parameter.
        This function adds the necessary {schema}.{table} notation.
        :param output_table_name:
        :param schema: an optional schema if the output_table has a schema set. Defaults to the temp schema
        :return:
        
In postgres, we set the schema in the query itself instead of as a query parameter.
This function adds the necessary {schema}.{table} notation.
In postgres we set the schema in the query itself instead of as a query parameter . This function adds the necessary { schema } . { table } notation .
def handle_output_table_schema(self, output_table_name, schema=None):
        schema = schema or SCHEMA
        if self.conn_type == "postgres" and self.schema:
            output_table_name = schema + "." + output_table_name
        elif self.conn_type == "snowflake" and self.schema and "." not in self.sql:
            output_table_name = self.database + "." + schema + "." + output_table_name
        return output_table_name
def handle_output_table_schema ( self , output_table_name , schema = None ) : schema = schema or SCHEMA if self . conn_type == "postgres" and self . schema : output_table_name = schema + "." + output_table_name elif self . conn_type == "snowflake" and self . schema and "." not in self . sql : output_table_name = self . database + "." + schema + "." + output_table_name return output_table_name
In postgres, we set the schema in the query itself instead of as a query parameter.
In postgres we set the schema in the query itself instead of as a query parameter .
"""
        In postgres, we set the schema in the query itself instead of as a query parameter.
        This function adds the necessary {schema}.{table} notation.
        :param output_table_name:
        :param schema: an optional schema if the output_table has a schema set. Defaults to the temp schema
        :return:
        """
None
self
output_table_name
None
schema
an optional schema if the output_table has a schema set. Defaults to the temp schema
an optional schema if the output_table has a schema set . Defaults to the temp schema