i want to do a into bog garden using aquariums, and like could i adapt this for inside, and just use the right type of light system? and what about the sand?
If you want a setup like that in the house, it will probably be quite messy and a chore to maintain. It's probably possible, but you will need really bright lighting, a place that won't get ruined from the peat and water, and a way to contain the water, among a host of other things.
In any case, what plants do you want to grow in it? You don't necessarily need a bog garden.
Good LED grow lights would be the best. You should expect to need a few tens of thousands of lumens per square meter.
I understand you want to grow CPs, but can you please give an idea of specifically what you want to put in it? (e.g. temperate sundews, venus fly traps, Sarracenia rubra). Different species have different lighting requirements, and some may not even like a bog garden. For example, Nepenthes would very quickly die in a bog garden, but something like Sarracenia purpurea would thrive.