How do I copy schemas and query results between connections for test data?

Export schema to create tables on a target connection (optional drop first). From a SELECT, Export Dataset into an existing target table with a record limit and optional clear. Connection JSON export/import shares connection sets (it includes credentials — treat it as a secret). CSV download is for fixtures, not a live target load.