A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which SQL commands can be used to append the new record to an existing Delta table my_table?
A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which SQL commands can be used to append the new record to an existing Delta table my_table?
To append a new record to an existing Delta table, the correct SQL command is 'INSERT INTO my_table VALUES ('a1', 6, 9.4)'. This command specifies the table 'my_table' and the values to be inserted for each column in the table.
Repeated, correct.