CheckTheChain

The CheckTheChain plugin is a tool for conducting on-chain analysis over blockchain and crypto protocol datasets. It can interact with datasets from various blockchains like Bitcoin, Ethereum, and Uniswap. Here are some of the things you can do with the CheckTheChain plugin:

1. Retrieve the schema of a given table in a given dataset. This can help you understand the structure of the data you're working with.
2. Retrieve a list of tables in a dataset. This can help you navigate the data available to you.
3. Retrieve a list of datasets. This can help you find the data you need for your analysis.
4. Execute a SQL query against the Google Big Query dataset. This allows you to perform complex analyses and extract specific information from the data.
5. Resolve an Ethereum address or ENS name. This can help you identify the owner of a specific address or ENS name.

These capabilities make the CheckTheChain plugin a powerful tool for anyone interested in conducting in-depth analysis of blockchain data.

Here's a step-by-step guide on how to use the CheckTheChain plugin:

1. Identify the Dataset: First, you need to identify the dataset you want to analyze. You can use the getDatasets function to retrieve a list of available datasets.
2. Identify the Table: Once you've identified the dataset, you can use the getTables function to retrieve a list of tables within that dataset.
3. Understand the Table Schema: After identifying the table, you can use the getTableSchema function to understand the structure of the data within that table.
4. Query the Data: Now that you understand the structure of the data, you can use the postQuery function to execute a SQL query against the dataset. This allows you to retrieve specific information from the data. Remember to specify the project name, dataset name, and table name in your query. Also, to ensure efficient and cost-effective queries, use WHERE, LIMIT, and TOP clauses to restrict the amount of data returned, specify the exact columns needed instead of using SELECT *, use functions like APPROX_COUNT_DISTINCT instead of COUNT DISTINCT, and minimize the use of JOIN operations.
5. Resolve Ethereum Addresses or ENS Names: If you're working with Ethereum data, you can use the resolveEthAddressOrEns function to resolve an Ethereum address or ENS name.

Remember, all these functions are used within the CheckTheChain namespace. For example, to get a list of datasets, you would use CheckTheChain.getDatasets({}).

Try this plugin in action