Package com.snowflake.connectors.common.table

Class DefaultTableLister

java.lang.Object

com.snowflake.connectors.common.table.DefaultTableLister

All Implemented Interfaces:

TableLister

public class DefaultTableLister
extends Object
implements TableLister

This implementation uses SHOW TABLES ... IN SCHEMA statement

Constructor Summary

Constructors

Constructor	Description
DefaultTableLister(Session session)	Creates a new DefaultTableLister.

Method Summary

Modifier and Type	Method	Description
List<TableProperties>	showTables(SchemaName schema)	Returns list of tables for a given schema.
List<TableProperties>	showTables(SchemaName schema, String like)	Returns list of tables for a given schema with additional filter expression.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DefaultTableLister

public DefaultTableLister(Session session)

Creates a new DefaultTableLister.

Parameters:

session - Snowpark session object

Method Detail

showTables

public List<TableProperties> showTables(SchemaName schema)

Returns list of tables for a given schema.

Specified by:

showTables in interface TableLister

Parameters:

schema - schema name

Returns:

list of tables for a given schema

showTables

public List<TableProperties> showTables(SchemaName schema,
                                        String like)

Returns list of tables for a given schema with additional filter expression.

Specified by:

showTables in interface TableLister

Parameters:

schema - schema name

like - filter expression (case-sensitive), e.g. MYTABLE or %TAB%

Returns:

list of tables