def METHOD_NAME(self, path: DbPath) -> str:
    database, schema, table = self._normalize_table_path(path)
    db_clause = ""
    if database:
        db_clause = f" AND redshift_database_name = '{database.lower()}'"
    return (
        f"""SELECT
            columnname AS column_name
            , CASE WHEN external_type = 'string' THEN 'varchar' ELSE external_type END AS data_type
            , NULL AS datetime_precision
            , NULL AS numeric_precision
            , NULL AS numeric_scale
        FROM svv_external_columns
            WHERE tablename = '{table.lower()}' AND schemaname = '{schema.lower()}'
        """
        + db_clause
    )