id_tables_in_dbs: Identify rows with given table name, database name, or schema...

In idea-analytics/ideadata: Tools and Utilities for accessing IDEA's Data Warehouse

Identify rows with given table name, database name, or schema in the MetaData table in the R&A's documentation database.

Description

Identify rows with given table name, database name, or schema in the MetaData table in the R&A's documentation database.

Usage

id_tables_in_dbs(.table_name, .server_name, .database_name, .schema)

Arguments

.table_name	the name of a table that may be located somewhere, as a quoted string
.server_name	the name of the server that hosts the database
.database_name	the name of a database in the warehouse , as a quoted string
.schema	the name of a schema in the warehouse, as a quoted string

Value

a tibble with all unique table, schema, database, and server combinations found in the MetaData table

Examples

## Not run: 
library(ideadata)

id_tables_in_dbs("Students")

## End(Not run)

idea-analytics/ideadata documentation built on Feb. 1, 2024, 5:40 a.m.