This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env bash | |
set -Eeuo pipefail | |
cd "$(dirname "${BASH_SOURCE[0]}")" >/dev/null 2>&1 | |
trap cleanup SIGINT SIGTERM ERR EXIT | |
usage() { | |
cat <<EOF |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* This query will look at a single project (by default in US multi-region) and | |
* calculate the logical and physical billing prices for each table in all datasets | |
* contained inside of it then provide a recommendation on if it is better to put it | |
* into a dataset that uses the logical (uncompressed) or physical (compressed) | |
* storage billing models. | |
* | |
* Physical (also called compressed) Storage went GA on July 5, 2023. It is set at | |
* the dataset level, so if two or more tables are better suited for different | |
* billing models in the same dataset it may be best to split them into separate |