setup.td 1.0 KB

1234567891011121314151617181920212223242526
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. $ kafka-create-topic topic=largeinput
  10. $ kafka-ingest topic=largeinput format=bytes
  11. A,B,0
  12. # The test intentionally does not go through toxiproxy.
  13. > CREATE CONNECTION IF NOT EXISTS kafka_conn TO KAFKA (BROKER '${testdrive.kafka-addr}', SECURITY PROTOCOL PLAINTEXT);
  14. > CREATE SOURCE largeinput
  15. FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-largeinput-${testdrive.seed}')
  16. > CREATE TABLE largeinput_tbl (city, state, zip) FROM SOURCE largeinput (REFERENCE "testdrive-largeinput-${testdrive.seed}")
  17. FORMAT CSV WITH 3 COLUMNS
  18. INCLUDE OFFSET
  19. > CREATE CONNECTION IF NOT EXISTS csr_conn TO CONFLUENT SCHEMA REGISTRY (
  20. URL '${testdrive.schema-registry-url}'
  21. );