Added a snippet to show how to read a newline-delimited-json file and store it in a Table #2974
Conversation
…m GCS and store it in a BQ Table.
googlebot
added
the
cla: yes
| .build(); | ||
| // Table field definition | ||
| ArrayList<Field> fields = new ArrayList<>(); | ||
| for (String fieldName: fieldNames) { |
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
| fields.add(Field.of(fieldName, LegacySQLTypeName.STRING)); | ||
| } | ||
| // Table schema definition | ||
| Schema schema = Schema.of(fields.toArray(new Field[fields.size()])); |
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
| Schema schema = Schema.of(fields.toArray(new Field[fields.size()])); | ||
| // Create the table | ||
| StandardTableDefinition tableDefinition = StandardTableDefinition.of(schema); | ||
| bigquery.create(TableInfo.of(tableId, tableDefinition)); |
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
| // [TARGET writer(WriteChannelConfiguration)] | ||
| // [VARIABLE "my_dataset_name"] | ||
| // [VARIABLE "my_table_name"] | ||
| // [VARIABLE "my_source_uri")] |
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
| // [VARIABLE "my_dataset_name"] | ||
| // [VARIABLE "my_table_name"] | ||
| // [VARIABLE "my_source_uri")] | ||
| // [VARIABLE "field_names")] |
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
|
After talking to Tim, I made some changes. Can you please review the changes? Thanks. |
|
Sorry I forgot about this earlier, but there's also a Python script to run which will ensure this sample gets included in the Javadocs for the library. The script is at https://github.com/GoogleCloudPlatform/google-cloud-java/blob/master/utilities/add_snippets_to_file.py |
| * } | ||
| * } </pre> | ||
| * | ||
| * <p>Example of creating a dataset. |
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
| * String query = | ||
| * "SELECT distinct(corpus) FROM `bigquery-public-data.samples.shakespeare` where word_count > ?"; | ||
| * <pre> {@code | ||
| * String query = "SELECT distinct(corpus) FROM `bigquery-public-data.samples.shakespeare` where; |
This comment was marked as spam.
This comment was marked as spam.
Sorry, something went wrong.
tswast
left a comment
tswast
left a comment
There was a problem hiding this comment.
Thanks!
Let's clean up some of the Javadoc strings in BigQuery.java manually and call this one done. I don't know what went wrong with the script.
5 participants
No description provided.