# dwh-assessment-extraction-tool **Repository Path**: mirrors_google/dwh-assessment-extraction-tool ## Basic Information - **Project Name**: dwh-assessment-extraction-tool - **Description**: No description available - **Primary Language**: Unknown - **License**: Apache-2.0 - **Default Branch**: main - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2021-10-22 - **Last Updated**: 2026-06-27 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # [deprecated] Data Warehouse Assessment Extraction Client > This repository is no longer maintained. Assessment Extraction Client has been moved to the [dwh-migration-tools](https://github.com/google/dwh-migration-tools) repository as part of BigQuery Migration Service. Please follow the BigQuery Migration Assessment [documentation](https://cloud.google.com/bigquery/docs/migration-assessment) for more details on how to use a new tool. This tool allows to extract meta information from a data warehouse that allows to make an assessment for migration. ## License Copyright 2021 Google LLC Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at https://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ## Building Install bazel: ``` sudo apt-get update sudo apt-get install bazel ``` Build an executable of the extraction client: Make sure the [teradata driver jar file terajdbc4.jar](https://downloads.teradata.com/download/connectivity/jdbc-driver) is in the same directory of the ExtractionTool_deploy.jar. Run the extraction tool with the teradata driver ``` java -cp ExtractionTool_deploy.jar:terajdbc4.jar com/google/cloud/bigquery/dwhassessment/extractiontool/ExtractionTool td-extract --db-address jdbc:teradata://localhost/DBS_PORT=1025,DATABASE=dbc --output tmp --db-user dbc --db-password dbc --schema-filter db:dbc --skip-sql-scripts users ``` ## Extraction tool user guide The extraction tool is currently intended for approved users that are engaging with GCP technical sales teams. **Step 1:** Follow the user guide from the GCP technical sales team and download the Extraction tool binary (i.e., ExtractionTool_deploy.jar) and its run script. **Step 2:** Download [Teradata JDBC driver](https://downloads.teradata.com/download/connectivity/jdbc-driver) into the same directory with the Extraction tool binary. **Step 3:** Create a folder for output files and run the Extraction tool: ```bash ./run-td-extract.sh -j --db-address --output --db-user ``` You can also append "--" to specify optional parameters, as ```bash ./run-td-extract.sh -j --db-address --output --db-user -- -- ``` See **Optional parameters** section for details about those parameters. Alternatively, ensure that your terajdbc driver is exactly named `terajdbc4.jar` and run ```bash ./dwh-assessment-execution-tool.sh td-extract --db-address --output --db-user -- ``` **Optional Parameters:** `--schema-filter` The schema filter to apply when extracting schemas from the database. By default, all schemas will be extracted. - Example usage: `--schema-filter db:(abc|def),table:public_.` Only take schemas from tables in the database abc or from tables whose names have the prefix public_. - Multiple filters can be defined by repeating the option. Each filter has to match (i.e. AND logic). `--sql-scripts` The list of scripts to execute. By default, all available scripts will be executed. - Available scripts extract metadata from tables and views: - [AllTempTablesVX](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/FVKCCZtalFF_UOT2PcPfrA) - [All_RI_ChildrenV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/CDg3b4d71cfITbRjAAQM5Q) - [All_RI_ParentsV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/KjM9MSv3K5G5Q_gCTNtGZw) - [ColumnsV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/fQ8NslP6DDESV0ZiODLlIw) - [DatabasesV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/GqTx8VuBIkfaC4fso9f5cw) - [DiskSpaceV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/ZhJCNhtQ1i4llpxKkYn7eA) - [FunctionsV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/hx9hvPb9EvS6TP9Ta2PUzQ) - [IndicesV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/qkWdqMUH7HZaIkY_pSQUng) - [PartitioningConstraintsV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/G5eOtdk_Z5xjAgAderQlQg) - [DBQLObjTbl](https://docs.teradata.com/r/B7Lgdw6r3719WUyiCSJcgw/eOMXq~u5PwRV5GrooD6_9A) - [QryLogV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/sT8ifzajeQ9jMx7ciiu1dA) - [QryLogSQLV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/SQqDiRkDlOLYNSZ4dBRIGQ) - [RoleMembersV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/y5EHNeWIu1uFk5714KHTaw) - [StatsV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/nLsDT6mdwnn1QrOG35ttMw) - [TablesV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/JKGDTOsfv6_gr8wswcE9eA) - [TableSizeV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/qQd_5O6fT0QrDcSfDEZj~Q) - [TableTextV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/h0HJktc4jYAtjKjVExdjUw) - [UsersV](https://docs.teradata.com/r/oiS9ixs2ypIQvjTUOJfgoA/rES2eYXMN2IBoFBIPIWz0Q) - [Click to view the scripts.](src/java/com/google/cloud/bigquery/dwhassessment/extractiontool/dbscripts) `--skip-sql-scripts` The list of scripts to skip. By default, all available scripts will be executed. For additional options to control running, apply filtering, skip schema extraction, etc., please run ```bash ./dwh-assessment-extraction-tool.sh td-extract -h ``` **Step 4:** The extraction process may take from a few minutes to hours to finish, depending on the amount of data in your database. Share the output files with the PSO Cloud Consultant.