Esempio n. 1
0
        public void TestListTables()
        {
            string datasetId  = "datasetForTestListTables";
            string newTableId = "tableForTestListTables";

            _tablesToDelete.Add(new Tuple <string, string>(datasetId, newTableId));
            _datasetsToDelete.Add(datasetId);
            CreateDataset(datasetId, _client);
            CreateTable(datasetId, newTableId, _client);
            // [START list_tables]
            var tables = _client.ListTables(datasetId).ToList();

            // [END list_tables]
            Assert.False(tables.Count() == 0);
        }
Esempio n. 2
0
    public void ListTables(
        string projectId = "your-project-id",
        string datasetId = "your_dataset_id"
        )
    {
        BigQueryClient client = BigQueryClient.Create(projectId);
        // Retrieve list of tables in the dataset
        List <BigQueryTable> tables = client.ListTables(datasetId).ToList();

        // Display the results
        if (tables.Count > 0)
        {
            Console.WriteLine($"Tables in dataset {datasetId}:");
            foreach (var table in tables)
            {
                Console.WriteLine($"\t{table.Reference.TableId}");
            }
        }
        else
        {
            Console.WriteLine($"{datasetId} does not contain any tables.");
        }
    }
Esempio n. 3
0
        // [END bigquery_list_datasets]

        // [START bigquery_list_tables]
        public List <BigQueryTable> ListTables(BigQueryClient client, string datasetId)
        {
            var tables = client.ListTables(datasetId).ToList();

            return(tables);
        }