I have 35 million rows any idea in how to migrate it?

[gvn182]

I have 35 million rows any idea in how to migrate it?

[ankane]

Hey @gvn182, migrate should be able to handle any number of rows (it’ll just take longer). The latest version has some optimizations, so I’d suggest using that.

[gvn182]

I see, is there any way to encrypt a field depending on an if? for example:

encrypts :email, if: self.account.crypt_enabled

[ankane]

No, a field can’t be conditionally encrypted. Can you explain more about your use case for that functionality?

[gvn182]

Yes, sure. As I said, i have around 35+ millions rows, I checked the Migrate function and it uses Batch, it would take a really long time to finish and I can't have a downtime of more than 2 hours. So I thought in the following strategy: Encrypt only new or really important customers (I have a multi tenant system divided by accounts)

So if I had the option to use a condition, I could apply this strategy.

[ankane]

No downtime is needed with migrate. You backfill the data first, then make the switch.

[gvn182]

I see, do you know if that's gonna work with a uuid ID?

[ankane]

Yeah, it should. Give it a shot and see how it goes.