Scratchpad

Paradime’s Scratchpad in the Code IDE allows for quick, temporary experiments in standard SQL and/or dbt™ (using ref, macros, etc). It provides instant data previews and organizes files in a dedicated folder. These files are gitignored to keep your repository clean and remain available across sessions, so you can continue your work seamlessly after logging out and back in.

​

Tutorial

When you create a new scratchpad file, it automatically generates a new folder named “paradime_scratch,” with individual gitignored files like “scratch-1”, “scratch-2” and so on, ensuring each scratchpad file is neatly organized. You can rename the files as needed.

​

Use Cases

• Draft code snippets that can be refined later, supporting various languages like SQL and dbt™
• Perform quick tests or experiments without affecting the main codebase.
• Quickly jot down notes or intermediary steps during development.
• Instantly preview SQL query results to validate and debug code.

​

Instant Data Explorer

Leverage the Data Explorer to preview your compiled SQL and results without having to first compile you dbt™️ resources.