Compute a hash of the data in the database schema. If the data changes, this should produce a different hash code. Specifically, the hash is based on the field names, field types, and table row counts.
computeDataHash(connection, databaseSchema, tables = NULL, progressBar = TRUE)Arguments
- connection
The connection to the database server created using either
connect()ordbConnect().- databaseSchema
The name of the database schema. See details for platform-specific details.
- tables
(Optional) A list of tables to restrict to.
- progressBar
When true, a progress bar is shown based on the number of tables in the database schema.
Value
A string representing the MD5 hash code.
Details
The databaseSchema argument is interpreted differently according to the different platforms:
SQL Server and PDW: The databaseSchema schema should specify both the database and the schema, e.g.
'my_database.dbo'. Impala: the databaseSchema should specify the database. Oracle:
The databaseSchema should specify the Oracle 'user'. All other : The databaseSchema should
specify the schema.