Defining databases in subfolder tree

[david-rowland-rozettatech]

I am currently evaluating atlas for deployment.

I would like to store the database files in the following structure:

schemas
     \schema1
            \tables
                   table1.hcl
                   table2.hcl
            \functions
                   function1.hcl
             \views
                    view1.hcl
     \schema2
               ...

I can't seem to get atlas to recognise the files in the sub folders.
I have so far trued to use include and env items but atlas just complains.

Can someone provide a simple sample of how this should be configured? We have too many objects in the database to include everything into one hcl file.
Thanks

[luantranminh]

Hi @david-rowland-rozettatech,

Atlas supports the fileset function, which allows you to load multiple files matching a specific pattern. This is especially useful when you want to treat several files as a single input source.

Here’s how you can use it in your case:

data "hcl_schema" "app" {
  paths = fileset("schemas/**/*.hcl")
}

env "output" {
  schema {
    src = data.hcl_schema.app.url
  }
  dev = "sqlite://file::memory:?cache=shared"
}

Then, you can run a command like this:

atlas schema diff --env output --from "sqlite://test.db" --to env://src

To improve the developer experience, we’ve also built IDE plugins:

• JetBrains plugin
• VS Code extension

With the Atlas plugin for JetBrains, you can easily navigate, edit, and reference resources across folders. To set it up:

1. Go to Settings > Languages & Frameworks > Atlas
2. Under Module Paths, click the + button to add directories
3. Enter the absolute path to any folder you’d like treated as a module root

Let me know if you need help setting it up!