Databrick - check wheher table exists in delta table

查询所有的Database

databases = [row.databaseName for row in spark.sql("SHOW DATABASES").collect()]

查询某个数据库是否存在

# 区分大小写
database_name = 'delta'
if database_name in databases:
  print('exists')
else:
  print('not exists')

获取数据库中所有的视图

views = spark.sql(f"SHOW VIEWS in {database_name}").collect()

获取视图名包含指定字符的视图

# 区分大小写
view_name = 'mty'
filtered_views = [view.viewName for view in views if view_name in view.viewName ]
print(filtered_views)

获取视图名以指定字符开头的视图

# 区分大小写
view_name = 'mty' 
filtered_views = [view.viewName for view in views if view.viewName.startswith(view_name)]
print(filtered_views)

获取视图名以指定字符结尾的视图

# 区分大小写
view_name = 'mty' 
filtered_views = [view.viewName for view in views if view.viewName.endswith(view_name)]
print(filtered_views)