Invalidates and then loads Spark in-memory cache for given table. Works only for views with in-memory caching configured. If the data for given table is not cached, just loads cache.
Syntax
lyft_invalidate_spark_cached_table 'tableName' [, 'schemaName' ] [, 'databaseName' ] [;]
Arguments
'tableName'
Name of the table for which cache will be invalidated.
'schemaName'
Name of database's schema in which table is present. When missing, current connection schema is used. Optional.
'databaseName'
Name of the database in which table is present. When missing, current connection database is used. Optional.
Example
Invalidates in-memory cache for Spark view AdventureWorksDW2012.dbo.DimCurrency.
EXEC lyft_invalidate_spark_cached_table @tableName = 'DimCurrency', @schemaName = 'dbo', @databaseName = 'AdventureWorksDW2012';